<? $pageTitle = 'Event Registration';$zdir = 1;include('../../includes/config.inc.php');include('../../includes/headerPrint.php'); ?><div id="genericPrintContent"><?
$eID = $_GET[eID];$sql = "SELECT C.CatName,P.ProgramName,U.UID,U.NameFirst,U.NameLast,U.Email,U.Phone1,U.PositionID		FROM casa_event_registration ER 		LEFT JOIN casa_users U ON ER.UID = U.UID		LEFT JOIN casa_programs P ON U.ProgramID = P.PID			LEFT JOIN casa_categories C ON C.CID = U.PositionID				LEFT JOIN casa_events E ON E.EID = '$eID' 		WHERE ER.EID = '$eID' ORDER BY ProgramName,NameLast";$result = mysql_db_query($dbname,$sql);$rows = mysql_num_rows($result);// Get event title$sql2 = "SELECT EventTitle from casa_events WHERE EID = '$eID'";$result2 = mysql_db_query($dbname,$sql2);$row = mysql_fetch_assoc($result2);$eventTitle = stripslashes($row[EventTitle]);
$returnString  = '<h1 style="margin-top: -30px;">'.$rows.' registered for '.$eventTitle.'</h1>';$returnString .= '<table class="dataTable" style="width: 100%;">';
$i=1;while ($value = mysql_fetch_assoc($result)) {	if (($i % 2) > 0) { $class = 'noRowClass'; }		else { $class = "altRow"; }		$uID       = $value[UID];	$program   = stripslashes($value[ProgramName]);	$nameFirst = $value[NameFirst];	$nameLast  = $value[NameLast];	$email     = $value[Email];	$phone     = $value[Phone1];	$position  = $value[CatName];
	$returnString .= '<tr class="'.$class.'" id="row'.$uID.'">';		$returnString .= '<td>'.$program.'</td>';		$returnString .= '<td>'.$nameLast.', '.$nameFirst.'</td>';		$returnString .= '<td><a href="mailto:'.$email.'">'.$email.'</a></td>';		$returnString .= '<td>'.$phone.'</td>';		$returnString .= '<td>'.$position.'</td>';	$returnString .= '</tr>';
	$i++;}$returnString .= '</table>';echo $returnString;?></div><? include('../../includes/footerPrint.php'); ?>